﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Wozuji.DBUtility;


namespace Wozuji.BLL
{
    public class getPage
    {

        public DataSet GetList(int PageSize, int PageIndex, string strWhere)
        {
            SqlParameter[] parameters = {
      new SqlParameter("@tblName", SqlDbType.VarChar, 255),
      new SqlParameter("@fldName", SqlDbType.VarChar, 255),
      new SqlParameter("@PageSize", SqlDbType.Int),
      new SqlParameter("@PageIndex", SqlDbType.Int),
      new SqlParameter("@IsReCount", SqlDbType.Bit),
      new SqlParameter("@OrderType", SqlDbType.Bit),
      new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
      };
            parameters[0].Value = "tbl_OverView";
            parameters[1].Value = "ViewID";
            parameters[2].Value = PageSize;
            parameters[3].Value = PageIndex;
            parameters[4].Value = 0;
            parameters[5].Value = 1;
            parameters[6].Value = strWhere;
            return DbHelperSQL.RunProcedure("UP_GetRecordByPage", parameters, "tbl_OverView");
        }


    }

}
